package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpContractCustomer;

/**
 * <p>
 * 合同协议缔约客户表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-17
 */
public interface ErpContractCustomerMapper extends BaseMapper<ErpContractCustomer> {
	@Select("SELECT * from erp_contract_customer cc where cc.contract_id in (${custId})  and cc.contracting_date <=#{time} and cc.customer_name = #{name}")
	public List<ErpContractCustomer> selectByCustIds(@Param("custId")String custId,@Param("time")String time,@Param("name")String name);
	
	@Select("SELECT * from erp_contract_customer cc where cc.contract_id in (${custId}) and cc.customer_name = #{name}")
	public List<ErpContractCustomer> selectByCustIdsAndName(@Param("custId")String custId,@Param("name")String name);
	
}
